package de.ihk.datamanagment;

import java.io.File;
import java.io.IOException;

import jxl.Cell;
import jxl.CellType;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

public class ExcelReader {
	private String inputFile;

	public void setInputFile(String inputFile) {
		this.inputFile = inputFile;
	}

	public void read() throws IOException {
		File inputWorkbook = new File(inputFile);
		Workbook w;
		try {
			w = Workbook.getWorkbook(inputWorkbook);
			// Get the first sheet
			Sheet sheet = w.getSheet(0);
			// Loop over first 10 column and lines
			for (int j = 0; j < sheet.getRows(); j++) {
				Cell cell = sheet.getCell(0, j);
				CellType type = cell.getType();
				if (type == CellType.NUMBER) {
					System.out.println("I got a number " + cell.getContents());
				}
			}

			// for (int j = 0; j < sheet.getColumns(); j++) {
			// for (int i = 0; i < sheet.getRows(); i++) {
			// Cell cell = sheet.getCell(j, i);
			// CellType type = cell.getType();
			// if (type == CellType.LABEL) {
			// System.out.println("I got a label "
			// + cell.getContents());
			// }
			//
			// if (type == CellType.NUMBER) {
			// System.out.println("I got a number "
			// + cell.getContents());
			// }
			//
			// }
			// }
		} catch (BiffException e) {
			e.printStackTrace();
		}
	}

	public static void main(String[] args) throws IOException {
		ExcelReader test = new ExcelReader();
		test.setInputFile("C:/Users/Dominik/workspaceNeu/IHK-Notes/resources/Schulliste Metall.xls");
		test.read();
	}

}